create table sys_role_menu
(
    role_id bigint not null,
    menu_id bigint not null,
    primary key (role_id, menu_id)
)
go

exec sp_addextendedproperty 'MS_Description', '角色和菜单关联表', 'SCHEMA', 'dbo', 'TABLE', 'sys_role_menu'
go

exec sp_addextendedproperty 'MS_Description', '角色ID', 'SCHEMA', 'dbo', 'TABLE', 'sys_role_menu', 'COLUMN', 'role_id'
go

exec sp_addextendedproperty 'MS_Description', '菜单ID', 'SCHEMA', 'dbo', 'TABLE', 'sys_role_menu', 'COLUMN', 'menu_id'
go

INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 2);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 3);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 100);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 101);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 102);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 103);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 104);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 105);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 106);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 107);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 108);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 109);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 110);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 111);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 112);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 113);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 114);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 115);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 116);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 500);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 501);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1001);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1002);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1003);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1004);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1005);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1006);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1007);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1008);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1009);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1010);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1011);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1012);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1013);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1014);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1015);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1016);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1017);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1018);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1019);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1020);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1021);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1022);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1023);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1024);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1025);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1026);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1027);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1028);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1029);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1030);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1031);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1032);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1033);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1034);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1035);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1036);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1037);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1038);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1039);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1040);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1041);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1042);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1043);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1044);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1045);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1046);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1047);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1048);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1049);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1050);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1051);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1052);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1053);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1054);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1055);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1056);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1057);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1058);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1059);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (2, 1060);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (3, 1);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (3, 104);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (3, 1021);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (3, 1022);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (3, 1023);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (3, 1024);
INSERT INTO [ry-vue].dbo.sys_role_menu (role_id, menu_id) VALUES (3, 1025);